Tabela Keys

Definicja tabeli Keys

Name

Keys

Code

Keys

Comment

 


Lista kolumn tabeli Keys

Name

Code

KeysID

KeysID

StepID

StepID

CostTypeID

CostTypeID

PeriodID

PeriodID

ResourceTypeID

ResourceTypeID

OrderingOrgUnitID

OrderingOrgUnitID

PerfOrgUnitID

PerfOrgUnitID

Value_1

Value_1

Value_2

Value_2

Coefficient

Coefficient


Kolumna KeysID tabeli Keys

Definicja kolumny KeysID tabeli Keys

Name

KeysID

Code

KeysID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StepID tabeli Keys

Definicja kolumny StepID tabeli Keys

Name

StepID

Code

StepID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CostTypeID tabeli Keys

Definicja kolumny CostTypeID tabeli Keys

Name

CostTypeID

Code

CostTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PeriodID tabeli Keys

Definicja kolumny PeriodID tabeli Keys

Name

PeriodID

Code

PeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceTypeID tabeli Keys

Definicja kolumny ResourceTypeID tabeli Keys

Name

ResourceTypeID

Code

ResourceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingOrgUnitID tabeli Keys

Definicja kolumny OrderingOrgUnitID tabeli Keys

Name

OrderingOrgUnitID

Code

OrderingOrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfOrgUnitID tabeli Keys

Definicja kolumny PerfOrgUnitID tabeli Keys

Name

PerfOrgUnitID

Code

PerfOrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Value_1 tabeli Keys

Definicja kolumny Value_1 tabeli Keys

Name

Value_1

Code

Value_1

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna Value_2 tabeli Keys

Definicja kolumny Value_2 tabeli Keys

Name

Value_2

Code

Value_2

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna Coefficient tabeli Keys

Definicja kolumny Coefficient tabeli Keys

Name

Coefficient

Code

Coefficient

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Lista kluczy tabeli Keys

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Keys

Definicja klucza Identifier_1 tabeli Keys

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment